    CREATE MATERIALIZED VIEW
      [ schema. ]materialized_view
      [ column_alias [, column_alias]... ]
      [ OF [ schema. ]object_type ]
      [ (scoped_table_ref_constraint) ]
      { ON PREBUILT TABLE
        [ { WITH | WITHOUT } REDUCED PRECISION ]
      | physical_properties materialized_view_props
      }
      [ USING INDEX
        [ physical_attributes_clause
        | TABLESPACE tablespace
        ]
          [ physical_attributes_clause
          | TABLESPACE tablespace
          ]...
      | USING NO INDEX
      ]
      [ create_mv_refresh ]
      [ FOR UPDATE ]
      [ { DISABLE | ENABLE }
        QUERY REWRITE
      ]
      AS subquery ;